package com.aspose.cells.examples.asposefeatures.worksheets;

import com.aspose.cells.Color;
import com.aspose.cells.MsoFillFormat;
import com.aspose.cells.MsoLineFormat;
import com.aspose.cells.MsoPresetTextEffect;
import com.aspose.cells.Shape;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;
import com.aspose.cells.examples.Utils;

public class AddWatermarkToWorksheet
{
    public static void main(String[] args) throws Exception
    {
        // The path to the documents directory.
        String dataDir = Utils.getDataDir(AddWatermarkToWorksheet.class);

        Workbook workbook = new Workbook();

        //Get the first default sheet
        Worksheet sheet = workbook.getWorksheets().get(0);

        //Add Watermark
        Shape wordart = sheet.getShapes().addTextEffect(MsoPresetTextEffect.TEXT_EFFECT_1,
        "CONFIDENTIAL", "Arial Black", 50, false, true
        , 18, 8, 1, 1, 130, 800);

        //Get the fill format of the word art
        MsoFillFormat wordArtFormat = wordart.getFillFormat();

        //Set the color
        wordArtFormat.setForeColor(Color.getRed());

        //Set the transparency
        wordArtFormat.setTransparency(0.9);

        //Make the line invisible
        MsoLineFormat lineFormat = wordart.getLineFormat();
        lineFormat.setVisible(false);

        //Save the file
        workbook.save(dataDir + "AsposeWatermark_Out.xls");

        System.out.println("Worksheet is watermarked now.");
    }
}
